Pharmacy Analytics section

The Clinical Analytics Pharmacy Analytics section allows hospitals and health systems to analyze the medications used by physicians based on various patient populations. It also allows users to identify any potential over-utilization of pharmaceuticals. This tool can be accessed in Clinical Analytics Scorecards by adding the Pharmacy Analytics section to any scorecard.

Customizer Mode

When in Customizer Mode, you can move, rename, or delete the section.

Click the green check to exit Customizer Mode and start your analysis.

Analytic options

  • This section is profiles-based, so you can select your Profile, Profile Period, and Benchmark Profile (if you select an internal Benchmark Profile, you can also select the corresponding Period).
  • The DRG icon below the profiles shows you the Grouping Type of your Profile.
  • You can export this section's table to Excel by clicking the Excel icon in the top right corner.

NOTE: All parameters in the Settings box are in addition to any filtering applied in the selected profile; remember this interaction when analyzing data.

Pharmacy Analytics template

This section offers Section-specific templates for you to save your settings; this saves you time and effort if you want to repeat your analysis later. Saving your parameters to the template preserves all of your selections in the Settings box, including the following settings.

Physician

Choose one or more physicians from the searchable list; not selecting a physician includes all physicians in the data.

Physician role

Select the Physician role that you would like to analyze; this limits the patient encounters to only those with the physician(s) selected above acting in the role selected here.

Role options include:

  • Attending
  • Operating (Principal Px)
  • Operating (Principal or Secondary Px)
  • Other
  • Consulting
  • Ordering
  • Clinical Analytics Attributed

Physician rollup

This selection allows you to choose how the data are displayed in the table.

Options include:

  • Expanded: Displays one row per physician ID per line item

  • Rollup: All selected physician data are rolled up into one line of data for each analysis

Facility

If you would like to filter by facility, select one or more facilities to be included; not selecting any facilities returns data for all facilities.

DRGs

Select one or more DRGs from the searchable list; not selecting a DRG includes all DRGs. The DRG numbers correspond with the DRG Type you selected.

SOIs

Select one or more SOIs from the searchable list; not selecting an SOI includes all levels of severity.

Drug Report level

Clinical Analytics utilizes First Data Bank’s Pharmacy Hierarchy to organize and aggregate NDC pharmacy data into six levels of drillable analytic reports.

Report level

Definition

Example 1

Example 2

Organ System

Highest and broadest level of classification organized by the specific organ(s) the drug targets

Cardiovascular System

Anti-infecting Agents

Pharmacological Class

Provides information about the specific drug class within a target organ system

Anti-hypertensives

Antibiotics

Therapeutic Class

Describes the drug’s mechanism of action to accomplish the therapeutic goal within the assigned pharmacological class

ACE Inhibitors

Penicillins

Generic Drug Name

Identifies the drug’s “active ingredient” to accomplish the mechanism of action or therapeutic goal

Captopril

Amoxicillin

Specific Generic Drug

Describes the strength or concentration of the generic drug

Captopril 25mg

Amoxicillin 250mg

National Drug Code

The National Drug Code (NDC) is assigned at the specific drug level

0143-1172-01

0143-9938-01

Drug Class filter

Select one filter level, then select one or more filters from the searchable list; not selecting a filter returns all drug classes. The filter level dropdowns change when you change the Drug Report Level; you are only able to filter on one level at a time and only filter levels at or higher than your selected Drug Report Level are available.

For example, when you select Therapeutic Class for your Report level, your filter dropdowns include only Organ System, Pharmacological Class, and Therapeutic Class.

Charges/Cost column

Select which value you would like displayed in the charges/costs column.

Report Column definitions

Remember that the column names are slightly different for each report level to provide you with the most applicable information for your analytics.

Column name

Definition

Number of Cases

Number of encounters with the same APR-DRG/SOI or MS-DRG as the cases that had a charge (see the following)

Number of Cases with Charges

Number of encounters that had a charge for the specific CDM

Number of Sys Cases

Number of encounters in the benchmark group with the same APR-DRG/SOI or MS-DRG as the system cases that had a charge (see below)

Number of Sys Cases with Charges

Number of encounters in the benchmark group that had a charge for the specific CDM

QTY (Quantity)

Total number of times selected physician(s) had a charge for each description; counts multiples for days of room and board, medications administrations, and so on.

Sys QTY

Total number of times benchmark group had a charge for each description; counts multiples for days of room and board, medications administrations, and so on.

Total Cost*

Total cost for all cases associated with the selected physician(s)

Sys Total Cost*

Total cost for all cases associated with the benchmark group

Average Quantity per Case

Physician Average Quantity per Case: Quantity divided by the number of cases for the selected physician(s)

Sys Avg Qty/Case

System quantity divided by the number of system cases if you have one DRG and/or SOI chosen. If you have more than one DRG and/or SOI chosen, the average system quantity per case is weighted to match the case mix of the selected physician

Percent of Cases Used

Number of cases with charges divided by the number of cases for the selected physician(s)

Sys % of Cases Used

Number of system cases with charges divided by the number of system cases if you have one DRG and/or SOI chosen. If you have more than one DRG and/or SOI chosen, the system percent of cases used is weighted to match the case mix of the selected physician

Diff % of Cases Used

Difference between the system and physician percent of cases used

Average Total Cost per Case*

Total cost divided by number of cases for the selected physician(s)

Sys Avg Total Cost/Case*

Total cost divided by number of cases for the selected physician(s)

Difference All Cases*

Difference between the physician and system average total cost per case, multiplied by the number of cases and rounded to the nearest dollar

*Column corresponds to your Charges/Cost Column parameter selection.